Users in the organization who have ProClarity Professional installed on their computers can use the supplied iMIS Analytics Briefing Book to analyze the data on the Analytics host. The Briefing Book is pre-configured with all the required connection information, so you need only to copy the Briefing Book from the iMIS application server where Analytics is installed to each user's computer.
Note: If you did not install ProClarity Professional on the appserver before installing Analytics, the Briefing Book will be missing required connection information. In this case, manually configure the connection information in the Briefing Book before you distribute it to Analytics users.
Before you begin
■ Analytics must be properly installed (see Installing Analytics) and configured.
■ A version of ProClarity Professional that supports SQL Server Analysis Services must be installed on the user's computer.
■ The client computer must be able to address the Analytics host (the database server host where the Analytics data warehouse and analysis database are installed) by using a standard Windows domain computer name.
To install the Analytics Briefing Book on client computers
Note: See your ProClarity Professional documentation for details.
1. Use Windows Explorer to copy the iMIS Analytics.bbk file from the Analytics folder on an iMIS application server where the optional Analytics product was installed (usually C:\Program Files\ASI\iMIS\Analytics).
2. Paste the iMIS Analytics.bbk file into an appropriate folder in the client computer (such as the user's My Documents folder).
3. Open the iMIS Analytics.bbk file in ProClarity Professional.
The Analytics data appears.
Troubleshooting connection issues with the Analytics Briefing Book
If the Briefing Book does not display the Analytics data, but instead prompts you to enter your username and password, the Briefing Book failed to connect to the Analytics host. This could be caused by one or both of the following issues:
■ The SQL Server host where the Analytics data warehouse and analysis databases are located is not addressable from the client computer by using a standard Windows domain computer name.
■ The Briefing Book is missing connection information, which can occur if you install Analytics before installing ProClarity Professional on an iMIS appserver.
Use the following steps to correct these issues:
1. Work with your network administrator and your database administrator to ensure that the client computer can address the Analytics host by domain name.
2. In ProClarity Desktop Professional, use the Change Connection Information Wizard to examine and modify the connection information defined in your original copy of iMIS Analytics.bbk Briefing Book. You must ensure that the Briefing Book uses the following values:
□ Provider - MSOLAP (SQL 9.0)
□ Server Name - the full domain name of the SQL Server instance that contains your Analytics analysis database (the Analytics host). If Analytics is installed in a named instance, you must use the naming convention [hostDomainName]\[instanceName].
□ Catalog - iAnalytics (this is configurable)
□ Cube - iMIS